2016-10-24 - 28256 - Enhancement - Sales Analysis with Discounts bex update #BExQueriesforCrystalReportsAnalysisTool

Enhancement

28256 - Sales Analysis with Discounts BEx update

Purpose


Need to update the Sales Analysis with Discounts BEx Query with MatGrp1, MatGrp2 & MatGrp3 infoobjects.

Admin Info


Purpose
Need to update the Sales Analysis with Discounts BEx Query with MatGrp1, MatGrp2 & MatGrp3 infoobjects
Requested By
Michael Carducci
Spec Created By
Uday Kumar P
Spec Created Date
10/24/2016
Spec QA by
Uday Kumar P
Objects
0MATL_GRP1, 0MATL_GRP2 and 0MATL_GRP3.
Document Status
Complete

Estimates


SNo
Activity
Estimation in Hours
1
Research
01
2
Documentation
02
3
Development/ Config
08
4
Unit test in DEV
02
5
Unit test in QUA
02
6
Other activity
02

TOTAL
16

References


Prior Tickets

None

Documents

None

Spec Changes


SNo
Change Details
Requested By
Requested On
Notes if any
1
Update text mappings to Material group 1, 2 & 3 info objects.
Mark Harris
10/27/2016
None




















Functional Requirement


Purpose/WHY:

Email from Mark Harris on 10/19/2016:
Can I get ‘Material Group 2’ and ‘Material Group 3’ added to the Sales Analysis with Discounts BEx? I believe we are already bringing over ‘Material Group 1’.

Email from Mark Harris on 10/26/2016:
The new fields for Material Groups 1, 2 and 3 appear to only be pulling the key for both text and key. Would it be possible to pull the description as the text and the key as the key. I checked the ZMMREP, they should have both.

In Scope:

Need to update text information to Material Group 1, Material Group 2 & Material Group 3 info objects.

Out of Scope:

None

Solution Summary


Changes on 10/24/2016:
1. Need to add Material Group 1, Material Group 2 and Material Group 3 info objects to Sales Analysis with discounts BEx Query.
2. Need to test the data in BPD & BPQ.

Changes on 10/27/2016:
1. Need to update the transformation for text mappings for Material Group 1, Material Group 2 and Material Group 3 info objects.
2. Need to test the data in BPD & BPQ.

Test Plan

SNo
Test Scenario
Expected Results
1
Check if the text data is shown in the BEx Analyser.
Text data should be shown for these objects in BEx Analyser.
2
Check if all the necessary objects are collected into the transport request.
All the required objects are collected into the transport request.

Solution Details


Changes on 10/24/2016:
1. Need to add Material Group 1(0MATL_GRP1), Material Group 2(0MATL_GRP2) and Material Group 3(0MATL_GRP3) info objects to Sales Analysis with discounts(VMP_OPASA_Q007) BEx Query.
2. Need to test the data in BPD & BPQ.

Changes on 10/27/2016:
1. Need to update the transformations for text mappings for Material Group 1(0MATL_GRP1), Material Group 2(0MATL_GRP2) and Material Group 3(0MATL_GRP3) info objects.
2. Need to test the data in BPD & BPQ.
3. Need to test if the text data as being shown in BEx Analysis.

Issues


None